Connected to Snowflake. Customer: KIVA Schema: KIVA_PROD.OPTIML 2023-02-03 2023-02-11
Category: Credit and dollar consumption trends ---------------------------------------------- category_name credits_previous_week dollars_previous_week credits dollars pct_change_dollars --------------- ----------------------- ----------------------- --------- --------- -------------------- Cloud services 56.65 113.3 43.71 87.42 -22.84 Compute 781.95 1563.91 768.67 1537.34 -1.7 Storage 0 55.71 0 60.96 9.42 Total 838.6 1732.91 812.38 1685.72 -2.72
Users: Credit consumption trends -------------------------------- user_name approximate_credits_previous_week approximate_credits pct_change_credits ---------------------- ----------------------------------- --------------------- -------------------- AMPLITUDE 0.17 0.27 58.82 DBT_DEV 74.13 72.58 -2.09 DBT_PROD 127.9 127.37 -0.41 FIVETRAN_USER 360.25 339.12 -5.87 FIVETRAN_USER_DEV 54.5 54.72 0.4 GREGORYW 0.94 1.19 26.6 GREGORYW_DEV 0.33 0.17 -48.48 LOOKER_DEV_ADMIN 3.6 3.51 -2.5 LOOKER_PROD 34.19 34.38 0.56 LOOKER_PROD_ADMIN 17.15 18.57 8.28 LOOKER_RAW_DEV 0.49 0.37 -24.49 LOOKER_RAW_PROD 3.97 4.05 2.02 MAXH_DEV 0.02 0.01 -50 ML_SERVICE_DEV 57.48 56.63 -1.48 ML_SERVICE_PROD 44.63 44.79 0.36 ROBS 0.41 0 -100 VERTEX_API_DEV 1.94 1.31 -32.47 VERTEX_API_DEV_JENKINS 0.84 0.39 -53.57 VERTEX_API_PROD 55.67 52.62 -5.48 JAY 0 0.01 inf OPTIML 0 0.3 inf Total 838.61 812.36 -3.13
List of low usage users (<1% of credits) with usage (Current month) ------------------------------------------------------------------- user_name approximate_credits percent_usage ---------------------- --------------------- --------------- AMPLITUDE 0.27 0.033 GREGORYW 1.19 0.146 GREGORYW_DEV 0.17 0.021 LOOKER_DEV_ADMIN 3.51 0.432 LOOKER_RAW_DEV 0.37 0.046 LOOKER_RAW_PROD 4.05 0.499 MAXH_DEV 0.01 0.001 ROBS 0 0 VERTEX_API_DEV 1.31 0.161 VERTEX_API_DEV_JENKINS 0.39 0.048 JAY 0.01 0.001 OPTIML 0.3 0.037
Warehouses: Credit consumption trends ------------------------------------- warehouse_name credits_previous_week credits pct_change_credits ------------------- ----------------------- --------- -------------------- DEV_WH 194.63 190.98 -1.88 ML_WH 35.25 35.59 0.96 PROD_AUX_WH 66.76 67.84 1.62 PROD_WH 541.96 517.97 -4.43 CLOUD_SERVICES_ONLY 0 0 0 Total 812.38 838.6 3.23
Client Application: Credit consumption trends --------------------------------------------- client_application_name approximate_credits_previous_week approximate_credits pct_change_credits ------------------------- ----------------------------------- --------------------- -------------------- Go 0.95 1.2 26.32 JDBC 474.73 454.98 -4.16 ODBC 58.44 54.33 -7.03 Python 304.46 301.86 -0.85 Snowflake UI 0.02 0.02 0 Total 838.6 812.39 -3.13